package cn.hust.springboot.mapper;

import cn.hust.springboot.bean.Emp;
import cn.hust.springboot.bean.EmpExample;
import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface EmpMapper {
    long countByExample(EmpExample example);

    int deleteByExample(EmpExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(Emp row);

    int insertSelective(Emp row);

    List<Emp> selectByExample(EmpExample example);



    Emp selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("row") Emp row, @Param("example") EmpExample example);

    int updateByExample(@Param("row") Emp row, @Param("example") EmpExample example);

    int updateByPrimaryKeySelective(Emp row);

    int updateByPrimaryKey(Emp row);

    Emp getEmpAndDeptById(Integer id);

    List<Emp> getEmpAndDept();
    List<Emp> selectReport();

    List<Emp> query(String name);

    List<Emp> getEmpAndDeptByDeptId(Integer id);

    List<Emp> getEmpAndDeptByPosId(Integer id);

    List<Emp> getEmpAndDeptResigned();

    List<Emp> getEmpAndDeptByDeptIdResigned(Integer id);

    List<Emp> getEmpAndDeptByDeptIdNew(Integer id);
}